﻿USE lm_db;

insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (1,'ABC2',1,1000,'Purchased Goods','grain','2011-12-06','2011-12-28',100,1,'rsg','Debit','2011-12-27 16:53:33','Cash',1,'Y','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (2,'ABC3',1,1000,'Purchased Goods','grain','2011-12-06','2011-12-28',100,1,'rsg','Debit','2011-12-27 16:59:10','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (3,'ABC4',1,1000,'Purchased Goods','grain','2011-11-28','2011-12-22',100,1,'iug','Debit','2011-12-27 17:27:05','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (4,'ABC5',4,12345,'Purchased Goods','grain','2011-11-27','2011-12-13',100,2,'werfew','Debit','2011-12-29 11:11:13','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (5,'ABC6',4,1465,'Purchased Services','grain','2011-11-29','2011-12-21',100,2,'tfy','Debit','2011-12-29 11:12:20','Cheque',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (6,'ABC7',1,100005,'Purchased Goods','grain','2011-12-04','2011-12-13',100,1,'gfhgf','Debit','2011-12-29 13:56:17','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (7,'ABC8',1,100005,'Purchased Goods','grain','2011-12-04','2011-12-13',100,1,'gfhgf','Debit','2011-12-29 13:57:49','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (8,'ABC9',4,10000,'Given On Rent','grain','2011-11-30','2011-12-28',100,2,'fs','Debit','2011-12-29 16:58:16','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (9,'ABC10',3,333,'Purchased Goods','fewf','2011-11-29','2011-12-14',111,2,'fdsfds','Debit','2011-12-29 17:01:59','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (10,'ABC11',5,5555,'Purchased Services','grain','2011-11-29','2011-12-21',100,2,'gdfd','Debit','2011-12-29 17:02:54','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (11,'ABC12',2,9999,'Purchased Services','grain',null,'2012-01-02',100,1,'45frewgr','Debit','2012-01-24 23:51:09','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (12,'ABC13',2,7777,'Purchased Services','grain','2012-01-01','2012-01-10',111,1,'yt','Debit','2012-01-24 23:53:21','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (13,'ABC14',1,10000,'Purchased Goods','grain','2012-01-15','2012-01-18',100,1,'egt','Debit','2012-01-24 23:56:25','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (14,'ABC15',1,1465,'Given On Rent','grain','2012-01-01','2012-01-29',100,1,'34rrqe','Debit','2012-01-24 23:57:46','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (15,'ABC16',2,11000,'Purchased Goods','grain','2012-01-01','2012-01-05',100,1,'fnfhf','Debit','2012-01-25 00:03:12','Cash',null,'N','N');
insert into `account`(`TransactionID`,`FormID`,`LocationID`,`Amount`,`Reason`,`ItemPurchased`,`TransactionDate`,`ReturnDate`,`InterestAmount`,`PersonID`,`Narration`,`TransactionType`,`DateTimerStamp`,`ModeOfPayment`,`TransactionAuthorizerID`,`Status`,`reject`) values (16,'ABC17',1,12321,'Purchased Goods','test','2011-12-26','2012-01-12',44,1,'adsfdsa','Debit','2012-01-25 12:57:37','Cash',null,'N','N');
